fbpx
Logo.
Menu_mob. Mob_closed.

Visualization
in Excel

The main image of the visualization in Excel.
130 min
€1450

Курс "Data visualization in Excel" is an important tool for various professional fields.

He will teach you effectively present complex data through pie charts, line and bar graphs, histograms, and more.

These skills will help you make your information more accessible and understandable for the audience, helping them to make informed decisions.

Learn how to present data professionally and make your work more efficient, by purchasing the course today!

Who will find it useful
visualization skills in Excel

Public figures
and activists

- for effective presentation of data on public initiatives, statistics on social projects, and research results, which will help to convey information to the general public and attract support.

Assistant managers

- To create professional reports and presentations that help managers make informed decisions based on clearly presented data.

Analysts

- For in-depth analysis and visual representation of data in various industries, including markets, sales, finance, and others. Visualization helps to convey complex information quickly and accurately.

Communicators of communal
services and engineering

- To analyze and present data on resource utilization, maintenance, development plans, and other important aspects related to the services provided.

Educators and teachers

- To present educational materials, prepare reports and research. Visualization allows you to simplify complex concepts and make them more understandable for students.

Journalists and media professionals

- To prepare information graphs, diagrams and other visual materials that make articles and reports more visual and understandable for readers.

Detailed content course

Pie charts
  • Flat and volumetric pie charts.
  • Manage chart elements: title, legend, data labels.
  • Select all items or a single item.
  • Angle of inclination of sectors, separation of one element.
  • Signature options, signatures with a separator, signature format.
  • The theme and color scheme of the current book.
  • Secondary pie chart: setting up the second row.
  • Quick chart layout.
Line and bar charts, histogram
  • Create a line graph.
  • Add or remove data from the chart.
  • Quick chart layout.
  • Data signatures for one row.
  • Bar chart.
  • Chart styles.
  • Use a cell value as an axis label or chart title.
  • Change the order of data series.
  • Data signatures for one point in a row.
  • Histogram.
  • Use a data filter on a chart.
  • Axis format: location of labels, setting the maximum and minimum values for the axis.
  • Data series format: overlapping rows, plane width.
  • Normalized bar chart.
  • Flip the axis.
  • Formatting the chart plane: How to remove axes and grid lines.
  • Formatting data signatures.
  • Change the chart type.
  • Row lines for a flat chart by accumulation.
Dot, bubble, and combination charts
  • A dot plot.
  • Customize axis labels from cells.
  • Data labels for a row of cells, a separator in the data label.
  • Using a data filter.
  • Bubble chart.
  • Axis format, data labels, and chart name from a cell.
  • Color selection of a single element.
  • Combined chart: bar and line graph, main and secondary axis.
  • Use the contents of merged cells to label an axis.
  • Accepts formatting of cell contents in a selected area.
  • Move the chart to a separate sheet for printing.
An additional method for selecting an element
  • Select one item by formula.
  • Create an additional data series that contains only one value.
  • Formatting rows: overlapping rows and plane width.
Additional charts
  • Features of creating names for additional types of charts.
  • Cascade chart, setting up a summary
  • Tree map and hierarchical sector map: on two or one row.
  • Formatting data signatures.
  • Pareto diagram: analyzing data on the contribution to the overall result.
  • Scatter plot: statistical data for a single row.
  • Frequency histogram: analyze the number of elements in a range, change the number of sections.
Pivot charts
  • Multiple pivot tables on one sheet, default table formatting.
  • Customizable sorting list.
  • Use filter values as chart labels.
  • Create summary charts: bar chart, pie chart, secondary pie chart.
  • Field buttons.
  • Formatting a histogram: reverse the labels, move axis labels and format them, and format data labels for a single row.
  • Combination chart: a regular bar chart and a line chart.
  • Setting up the main and auxiliary axes, formatting labels for each axis separately.
  • Secondary pie chart: setting up the second part (number of values and how to divide the rows).
  • Transfer the pivot chart to a separate sheet.
  • Connect multiple reports to a single separator.
Conditional formatting - part 1
  • Basic rules of conditional formatting: repeated and unique values, "equal to" and "contains" rules. rules for dates.
  • Rules for conditional formatting of numbers.
  • Select cells that have conditional formatting applied to them.
  • View conditional formatting rules applied to the selected fragment.
  • Histograms.
  • Rules for formatting the first and last values.
  • Icons as a visualization of trends and as an indicator of goal achievement.
Conditional formatting - part 2
  • Select multiple ranges.
  • Create your own rule for conditional formatting using a formula.
  • Formulas with calculations to highlight numbers.
  • Formulas with functions on the example of working with dates.
Mini-charts
  • Win-loss mini-chart to highlight positive and negative values.
  • Bar graph mini-chart.
  • Set color for different types of points (largest, smallest, first, last, negative points).
  • Line mini-chart with multiple cells.
  • An example of trend and limit point analysis using mini-charts.
Final testing
  • 20 questions, passing score 70% (14 questions), the number of attempts is infinite, the time is not limited.

Demo video

Metodi training

The learning methods in this Excel course are designed to simulate real-life work with the program, where participants engage in interactive activities to practice skills in conditions that closely resemble real-life work situations. Key learning methods include:

Interactive tasks

Tips for interactive tasks

Choosing the right answers

Entering values in cells

Peredumovi
to start learning

To enroll in the Visualization in Excel course, participants must have:

Access to a computer with Microsoft Excel installed is also required for self-paced repetition of practical exercises and hands-on training.

Other Excel online course

Excel Basic Online Course

Excel course

Data analysis

Common question.

Do I need to have basic Microsoft Excel skills to participate in this data analytics course?

To participate in the course on data analysis in Excel, it is recommended that you have certain basic skills: the basics of Excel, including working with data and basic functions, and desirable skills in creating formulas and working with pivot tables, which will facilitate the learning of the course material.

How does the course work?

The Excel course includes simulations, interactive exercises, and practical tasks that allow participants to learn at their own pace.

Will participants receive a certificate after completing the course?

Upon successful completion of the course, participants can receive an individual certificate. The conditions for obtaining a certificate (for example, the number of points scored, the material listened to, or the results of the final test) are determined by the customer.

Is there any access to the materials after the course?

The customer can independently customize the conditions of access to the materials after completing the course in accordance with the requirements of their company.

Is there a possibility of free familiarization with the course or its trial version?

A demo version of the course is available on this page. On request, you can also access individual elements of the course to adapt it to your specific needs.